﻿
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[sproc_BBS_UpdateBoardInfo]') AND type in (N'P', N'PC'))
    DROP PROCEDURE [dbo].[sproc_BBS_UpdateBoardInfo];
GO
CREATE PROCEDURE [dbo].[sproc_BBS_UpdateBoardInfo]
    @board_id int,
    @board_name nvarchar(300),
    @board_description nvarchar(300),
    @board_type bit
/*

===================================================================================
功能:    更新板块信息
参数:    
    @board_id int,                :    被更新的板块ID            
    @board_name nvarchar(300)        :    板块名称
    @board_description nvarchar(300),    :    板块介绍
    @board_type bit                :    板块类型(公共型，私有型)
===================================================================================

*/    
AS
UPDATE uds_bbs_board 
    SET board_name =@board_name,
        board_description = @board_description,
        board_type = @board_type
    WHERE board_id = @board_id